Analysis of Big Tech Stock Prices

INFO 523 - Spring 2023 - Project 1

Christian Ortmann, Roxana Akbarsharifi, Abhishek Kumar, Shashank Yadav, Gorantla Sai Laasya, Divya Liladhar Dhole

Introducing the Dataset

  • Data was sourced from Tidy Tuesday, which pulled from Kaggle
  • Dataset consists of 14 Big Tech stocks and their respective economic metrics from 2010 to 2022
  • Contains some missing data points where companies were listed after 2010
  • Motivated to make low risk financial decision by analyzing past stock market trends

Question 1: How do stock prices change over time based on basic economic metrics

<<<<<<< HEAD
======= <<<<<<< HEAD
>>>>>>> 8538c63 (pres changes)

Line Plot and Bar Plot

<<<<<<< HEAD
======= <<<<<<< HEAD
>>>>>>> 8538c63 (pres changes)
<<<<<<< HEAD
======= <<<<<<< HEAD
>>>>>>> 8538c63 (pres changes)
<<<<<<< HEAD

Insights

=======

Analysis

Company %CAGR
TSLA 41.51
NFLX 32.37
NVDA 30.47
AAPL 24.36
AMZN 21.53
ADBE 18.54
MSFT 17.13
CRM 16.28
GOOGL 14.25
META 13.15
ORCL 9.57
CSCO 5.17
INTC 1.77
IBM 0.83
Company Correction %
IBM -56.08%
TSLA -44.47%
CSCO -42.80%
INTC -34.84%
META -34.59%
ORCL -33.83%
CRM -33.05 %
NVDA -32.12 %
AAPL -30.82%
GOOGL -28.99%
NFLX -28.67%
MSFT -21.62%
ADBE -20.10%
AMZN -17.79%

Insight

  • All 14 stocks have a positive CAGR (compounded annual growth rate) over the twelve year period
  • Each company’s share price dropped by at least 15%
  • Apple (AAPL) is the most popular stock based on trading volume

Question 2:

>>>>>>> 8538c63 (pres changes)

Question-2 Backwards verification: if we invested x amount of dollars in 2010, how much would it be worth in 2022, when would be a good/bad time to pull investment out of the market

Insights

  • The Tesla’s stock price experienced significant growth from 2012 to 2022, increasing by a factor of 10 during that period when normalized to a particular reference point.

  • The 50-DMA of the stock price consistently exceeds the 200-DMA.

  • The Netflix is another example where 200-DMA stock price is more than 50-DMA.

<<<<<<< HEAD =======

Normalized Stock Price over Time

50, 200 Day Moving Averages

<<<<<<< HEAD
=======
>>>>>>> c53c7fd (pres changes)

Insights

>>>>>>> 8538c63 (pres changes)

Conclusion

Thank You!